Returning multiple Rows from PL/pgSQL-Function

Hi,

I want to create a function (PL/pgSQL), which return multiple rows. But it
fails -- when Creating the function, I get a notice:
 NOTICE:  ProcedureCreate: return type 'records' is only a shell


When executing it, this error:
 ERROR:  fmgr_info: function 0: cache lookup failed


How should I do this?


The function is simple:
  CREATE FUNCTION foo (timestamp) RETURNS SETOF records AS        '       BEGIN          RETURN SELECT * FROM table;
  END;       ' LANGUAGE 'plpgsql';  
 


or, in more detail the exact function:

  CREATE FUNCTION get_emotions (timestamp) RETURNS SETOF records AS         '        DECLARE            start ALIAS FOR
$1;          end_id int4;        BEGIN           SELECT emotion_id FROM emotions                             WHERE date
<=start                             LIMIT 1                              INTO end_id;           RETURN SELECT
emotion_id,emotion1, [...]                 FROM  emotions                  WHERE emotion_id BETWEEN end_id-3000 AND
end_id                ORDER BY date_epoch + full_rating*(3600*12)                 LIMIT 300;        END;        '
LANGUAGE'plpgsql'; 
 



Thanx for any help!


Ciao Alvar



-- 
| AGI ............................................................... |
| Magirusstrasse 21B, 70469 Stuttgart . Fon +49 (0)711.228 74-50 .... |
| http://www.agi.com/diary/ (english) . http://www.agi.de/tagebuch/ . |
| >>>>>> NEWS >>> AGI holt Bronze-Loewen in Cannes! <<<<<<<<<<<<<<<<< |